{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["GEF IW Tracking Tool","Stress Reduction Dropdowns"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"GEF IW Tracking Tool","index":0,"n_rows":42,"n_cols":7,"rows_kept":42,"merged":[[1,2,1,6],[4,5,4,6],[7,2,7,6],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,2,21,6],[22,3,22,5],[23,3,23,5],[24,1,26,1],[24,2,26,2],[24,4,24,5],[24,6,26,6],[25,3,26,3],[25,4,26,5],[27,1,34,1],[27,2,27,6],[28,4,28,5],[29,2,30,2],[29,4,29,5],[30,3,30,6],[31,2,32,2],[31,4,31,5],[32,3,32,6],[33,2,34,2],[33,4,33,5],[34,3,34,6],[35,2,35,6],[36,3,36,5],[37,3,37,5],[38,2,38,6],[39,3,39,5],[40,3,40,5],[41,3,41,5]],"flags":["formulas_cached_only"]}
[]
[null,null,"GEF International Waters Composite Track Tool "]
[]
[{"$nulls":5},"GEF ID: 4092","GEF Agency: World Bank"]
[null,null,"Select Replenishment  (GEF 3, GEF 4, GEF 5):","GEF 4",null,"Project Title: Huai River Basin Marine Pollution Reduction"]
[null,null,"Select Objective \n(Obj 1, Obj 2, Obj 3, Obj 4):","Obj 2",null,"GEF Allocation ($): 5 million","Countries: China"]
[]
[null,"A","PROCESS Indicators"]
[null,null,"Indicators","Scroll down menu of ratings",null,null,"Ratings"]
[null,1,"Regional legal agreements and cooperation frameworks ",{"$nulls":3},"1 = no legal agreement/cooperation framework in place\n2 = regional legal agreement negotiated but not yet signed\n3 = Countries signed legal agreement\n4 = Legal agreement ratified and entered into force"]
[null,2,"Regional management institutions (RMI)",{"$nulls":3},"1 = No RMI in place\n2 = RMI established but functioning with limited effectiveness, < 50% countries contributing dues\n3 = RMI established and functioning, >50% of countries contributing dues\n4 = RMI in place, fully functioning and fully sustained by at or near 100% country contributions"]
[null,3,"Management measures in ABNJ incorporated in  Global/Regional Management Organizations (RMI) institutional/ management frameworks",{"$nulls":3},"1 = No management measures in ABNJ  in  (RMI) institutional/ management frameworks\n2 = Management measures in ABNJ designed but not formally adopted by project participants\n3 = Management measures in ABNJ  formally adopted by project participants but not incorporated in RMI institutional/management frameworks\n4 = Management measures in ABNJ fully incorporated in  RMI institutional/ management frameworks"]
[null,4,"National Inter-Ministry Committees (IMCs)",{"$nulls":3},"1 = No IMCs established\n2 = IMCs established and functioning, < 50% countries participating\n3 = IMCs established and functioning, > 50% countries participating\n4 = IMCs established, functioning and formalized thru legal and/or institutional arrangements, in most participating countries"]
[null,5,"National/Local reforms ",{"$nulls":3},"1 = No national/local reforms drafted\n2 = National/ local reforms drafted but not yet adopted\n3 = National/legal reform adopted with technical/enforcement mechanism in place\n4 = National/ legal reforms implemented"]
[null,6,"Transboundary Diagnostic Analysis (TDA): Agreement on transboundary priorities and root causes",{"$nulls":3},"1 = No progress on TDA\n2 = Priority TB issues identified and agreed on but based on limited effect information; inadequate root cause analysis\n3 = Priority TB issues agreed on based on solid baseline effect info; root cause analysis is inadequate\n4 = Regional agreement on priority TB issues drawn from valid effect baseline, immediate and root causes properly determined"]
[null,7,"Revised Transboundary Diagnostic Analysis (TDA)/Strategic Action Program (SAP) including Climatic Variability and Change considerations",{"$nulls":3},"1 = No revised TDA or SAP\n2 = TDA updated to incorporate climate variability and change\n3 = revised SAP prepared including Climatic Variability and Change\n4=  SAP including Climatic Variability and Change adopted by all involved countries"]
[null,8,"TDA based on multi-national, interdisciplinary technical and scientific (MNITS) activities ",{"$nulls":3},"1= TDA does not include technical annex based on MNITS actives\n2= MNITS committee established and contributed to the TDA development\n3= TDA includes technical annex, documenting data and analysis being collected\n4= TDA includes technical annex posted IWLEARN and based on MNITS committee inputs\n "]
[null,9,"Development of Strategic Action Plan (SAP)  ",{"$nulls":3},"1 = No development of SAP\n2 = SAP developed addressing key TB concerns spatially\n3 = SAP developed and adopted by ministers \n4 = Adoption of SAP into National Action Plans (NAPs)"]
[null,10,"Proportion of Countries that have adopted SAP",{"$nulls":3},"(number of countries adopted SAP / total number of countries - e.g.. 3 countries adopted /10 total countries in project, so 3/10)"]
[null,11,"Proportion of countries that are implementing specific measures from the SAP (i.e. adopted national policies, laws, budgeted plans)",{"$nulls":3},"(number of countries implementing adopted SAP / total number of countries - e.g.. 3 countries implementing /10 total countries in project, so 3/10) "]
[null,12,"Incorporation of (SAP, etc.) priorities with clear commitments and time frames into CAS, PRSPs, UN Frameworks, UNDAF, key agency strategic documents including financial commitments and time frames, etc",{"$nulls":3},"1=No progress \n2=Limited progress, very generic with no specific agency/government(s) commitments\n3=Priorities specifically incorporated into some national development/assistance frameworks with clear agency/government(s) commitments and time frames for achievement\n4=Majority of national development/assistance frameworks have incorporated priorities with clear agency/government(s)  commitments and time frames for achievement\n"]
[null,"B","STRESS REDUCTION Indicators"]
[null,null,"Indicators","Scroll down menu of ratings",null,null,"Ratings"]
[null,13,"Are there mechanisms in place to produce a monitoring report on stress reduction measures?",{"v":1,"d":"1.0"},null,null,"1 = No mechanisms in place to monitor/report change\n2 = Some national/regional monitoring mechanisms, but they do not satisfy the project related indicators.\n3 = monitoring mechanisms in place for some of the project related indicators\n4 = Mechanisms in place and sustainable for long-term monitoring"]
[null,14,"Stress reduction measurements incorporated by project under management of: ","Choose proper management mechanism from drop down list below:","Area currently under protection out of total area identified by project \n(e.g.. 10,000 / 100,000 Ha):",null,"Management Mechanisms:\n1) Integrated Water/River Resource Management (Watershed, lakes, aquifers)\n2) Integrated Coastal Management  (Coast)\n3) Marine Spatial Planning (Marine)\n4) Marine Protected areas (Fisheries/ABNJ)  \n"]
[{"$nulls":3},1,"Not Applicable"]
[]
[null,15,"Please specify the types of Technologies and measures implemented in local demonstrations and investments:"]
[{"$nulls":3},"Stress Reduction Measurements","Units of Measurements"]
[null,null,"Local investment #1",1,"reduction of 87.6 ton of COD; 4.6 ton of SS, 0.743 ton of TP; and 5.883 ton of TN in 2014 ",null,"Choose one local investment type and units of measurements from the drop down menus (which at present, can be found in other worksheet of this Excel file)"]
[{"$nulls":3},"Construction of (i) rural domestic wastewater treatment works for on-site treatment of domestic wastewater in eight villages; (ii) about 1,500 manure storage tanks on livestock farms of participating villages; and (iii) a centralized composting facility to collect and treat livestock wastes from all animals in two villages."]
[null,null,"Local investment #2",3,"reduction of 1.71 ton of TN, 0.123 ton of TP in 2014 ",null,"Choose one local investment type and units of measurements from the drop down menus (which at present, can be found in other worksheet of this Excel file)"]
[{"$nulls":3},"Introduction of agricultural pollution reduction technologies and management practices in Participating  Villages through  comprehensive and balanced fertilizer applications, provision and use of insect luring lamps,  and construction of eco-trenches and buffer strips in crop fields and monitoring of the results of implementation of these technologies and practices."]
[null,null,"Local investment #3",17,"reduction of 430 ton of COD, 215 ton of BOD, 129 ton of NH3-H, 12 ton of TP in 2014 ",null,"Choose one local investment type and units of measurements from the drop down menus (which at present, can be found in other worksheet of this Excel file)"]
[{"$nulls":3},"Construction of a wetland (1.8 km2) consisting of water regulation structures, a bio-retention pond, and free surface wetlands with a daily treatment capacity of about 70,000 m3 between March and November, and 25,000 m3 between December and February, i.e., about 43% and 15% of total water flow in Guangli river during the summer and the winter seasons respectively."]
[null,"C","WATER, ENVIRONMENTAL & SOCIOECONOMIC STATUS Indicators"]
[null,null,"Indicators","Scroll down menu of ratings",null,null,"Ratings"]
[null,16,"Are there mechanisms and project indicators in place to monitor the environmental and socioeconomic status of the waterbody?             \n",{"v":1,"d":"1.0"},null,null,"1 = No mechanisms in place \n2 = Some national/regional monitoring mechanisms, but they do not satisfy the project related indicators.\n3 = monitoring mechanisms in place for some of the project related indicators\n4 = Mechanisms in place for project related indicators and sustainable for long-term monitoring "]
[null,"D","IW:LEARN Indicators"]
[null,null,"Indicators","Scroll down menu of ratings",null,null,"Ratings"]
[null,17,"Participation in IW events (GEF IWC, Community of Practice (COP), IW:LEARN)",{"v":1,"d":"1.0"},null,null,"1 = No participation\n2 = Documentation of minimum 1 event or limited COP participation\n3 = Strong participation in COPs and in IWC\n4 = Presentations with booth participation and hosting of staff/twinning"]
[null,18,"Project website (according to IW:LEARN guidelines",{"v":1,"d":"1.0"},null,null,"1 = no project website\n2 = Website not in line with IW:LEARN guidelines, not regularly updated\n3 = Website in line with IW:LEARN guidelines, not regularly updated\n4 = Website in line with IW:LEARN guidelines, regularly updated"]

{"sheet":"Stress Reduction Dropdowns","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[1,1,1,5]],"flags":["formulas_cached_only"]}
[]
[null,"The below stress reduction measures are to be found as drop down menues Under Stress Reduction Indicators. Hence they will not be sitting in its own worksheet when the IW tracking tool is finalised, but will become drop-down menues that are linked to each other"]
[]
[null,"#","Stress Reduction Measures",null,null,"UNITS of measurements"]
[null,1,"municipal wastewater pollution reduction",null,null," N, P & BOD (kg/yr)"]
[null,2,"industrial wastewater pollution reduction",null,null,"pollutant; estimated kg/yr"]
[null,3,"agriculture pollution reduction practices",null,null,"ha of practices; estimates of N, P & BOD  kg/yr"]
[null,4,"restored habitat, including wetlands ",null,null,"ha restored"]
[null,5,"conserved/protected wetland, MPAs, and fish refugia habitat",null,null,"ha applied"]
[null,6,"reduced fishing pressure",null,null,"tons/yr reduction; % reduction in fleet size"]
[null,7,"improved use of fish gear/techniques",null,null,"% vessels applying improved gear/techniques"]
[null,8,"water use efficiency measures",null,null,"m^3/yr water saved"]
[null,9,"Improved irrigation practices",null,null,"m^3/ha/yr water saved"]
[null,10,"Alternative livelihoods introduced",null,null," # people provided alternative livelihoods"]
[null,11,"Catchment protection measures",null,null,"ha under improved catchment management"]
[null,12,"Aquifer pumping reduction",null,null,"m^3/yr water saved"]
[null,13,"Aquifer recharge area protection",null,null,"ha protected"]
[null,14,"Pollution reduction to aquifers",null,null,"kg/ha/year reduction"]
[null,16,"Invasive species reduction",null,null,"ha and/or #'s of targeted area"]
[null,17,"Other… Please specify:"]